﻿CREATE TABLE [dbo].[Enterprise] (
    [EnterpriseId]    INT          IDENTITY (1, 1) NOT NULL,
    [Name]            VARCHAR (50) NOT NULL,
    [Title]           VARCHAR (50) NULL,
    [Active]          bit NOT NULL DEFAULT 1,
    [adt_DateCreated] DATETIME     CONSTRAINT [DF_Enterprise_adt_DateCreated] DEFAULT (getdate()) NOT NULL,
    [adt_CreatedBy]   VARCHAR (50) NULL,
    CONSTRAINT [PK_Enterprise] PRIMARY KEY CLUSTERED ([EnterpriseId] ASC)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_Enterprise]
    ON [dbo].[Enterprise]([Name] ASC);

